﻿using System.Data;
using System.Data.SqlClient;

namespace MyWeb.Data
{
    public class ProductSizeController : SqlDataProvider
    {
        #region [ProductSize_GetByAll]

        public DataTable ProductSize_GetByAll()
        {
            return GetDataTable("sp_ProductSize_GetByAll");
        }

        #endregion

        #region [ProductSize_GetById]

        public DataTable ProductSize_GetById(int id)
        {
            var p1 = new SqlParameter("@Id", id);
            return GetDataTable("sp_ProductSize_GetById", p1);
        }

        #endregion

        #region [ProductSize_GetByProductId]

        public DataTable ProductSize_GetByProductId(string iProductId)
        {
            var p1 = new SqlParameter("@Product_Id", iProductId);
            return GetDataTable("sp_ProductSize_GetByProductId", p1);
        }

        #endregion
    }
}